Activity Based Costing - Report Configuration
The "Activity Based Costing" report has an option to use "Integration Data" as the source of actual costs from the finance system against an activity.
The menu option "Strategic Maintenance Planning"->"Reports Configuration"->"Activity Based Costing" is used to configure the integration data source.
The data source is the finance system and is defined by a database query.
The finance system data, therefore, needs to be in a database (rather than via a web service or other types of data source).
The "Report Configuration" allows a database query to be defined to return the following fields:
- accno - this is the account number of the activity within the finance system.
A corresponding work activity will have been configured in Assetic myData with the accno recorded in the "General Ledger" field of the work activity. - q1total - the total costs recorded against the accno for the First Quarter of the Financial Year.
- q2total - the total costs recorded against the accno for the Second Quarter of the Financial Year.
- q3total - the total costs recorded against the accno for the Third Quarter of the Financial Year.
- q4total - the total costs recorded against the accno for the Fourth Quarter of the Financial Year.
This query may be performed directly against the financial system tables, or via a database view that consolidates this information.
Another option is a database table created specifically for this report and populated automatically via scheduled task on a periodic basis.
This allows other data sources such as web services to be used to first extract the information in the finance system and then place that in the reporting table.
Database Connection
The database connection to the finance database is defined via the "Report Data Source Configuration" tool initiated from the "Data Integration"->"SMP Configuration" menu.
The connection may be either an SQL Server or Informix database.
It has the typical connection options for database sources as shown in the screenshot below:
